In Oracle, the state of the regular user becomes locked, expired, and so on, how to deal with this situation?First, if the locked state is OK, the DBA executes the ALTER user Scott account unlock directly.However, if it becomes a expired state,
Oracle TIP error message ora-28001:the password has expired is due to the new features of oracle11g, oracle11g the default password expiration limit when creating a user is 180 days (that is, 6 months). If the user password has not been modified for
First to complain, obviously just finished writing, released when said did not land, all of a sudden.Today open EM Discovery tips
ora-28001:the Password has expired (DBD Error:ocisessionbegin)
So I looked up the
ORACLE Account Tips EXPIRED (GRACE) Problem Solving2013-01-30 15:09:24Tags: Oracle userOriginal works, allow reprint, please be sure to use hyperlinks in the form of the original source of the article, author information and this statement.
ORA-28001: the password has expired solution, ora-28001expired
Oracle prompt error message ORA-28001: the password has expired, due to new features of Oracle11G, the default password expiration limit for Oracle11G User Creation is 180 days (6
Oracle 11g password expired locked reporting ORA-28000 the account is locked
I. Reasons for triggering this error and Related Factors
It is because "PASSWORD_LIFE_TIME = 180 days" is set in the default profile in Oracle 11g by default. in Oracle 11g,
Oracle 11g default password expiration time is 180 days,After the password expires, the following exception occurs when you access the database:java.sql.sqlexception:ora-28001:the Password has expiredQuery Password expiration settings:SELECT * from
An exception occurred while debugging a Web project:
java.sql.sqlexception:ora-28001:the Password has expired
Check online, is the reason why the oracle11g password expiresConnect Oracle, log in as Oracle user, enter the following
Solution for Oracle Database User Account being expired
The Oracle database account has expired. You must change the password before you can use it again.
But sometimes, for various reasons, we do not know what the plain text of the original
Oracle 11g password expired lock reported ORA-28000 the account is locked, 11gora-28000
I. Reasons for triggering this error and Related Factors
This is because "PASSWORD_LIFE_TIME = 180 days" is set in the default profile in oracle11g by
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.